Model Table CRM MEASURES

Attributes

Attribute

Description (where applicable)

Measures (table to be generated as far as possible)

Aggregation of measures is based on SUM if not explicitly noted.

This section describes the basic measures in the cube. These are either measures defined in the core Information Source, in the model itself or in the ETL process. The columns have the following meaning:

Core Measure: A measure that has its origin in a core Information Source
Calculated Y/N: A measure specifically defined for the model, e.g. percentages etc. These measures do not derive from the Information Source.
Contains Time Intelligence Y/N: Some measures do also have additional time intelligence measures like Year To Date (YTD) Se separate section.
Definition/Note: Specifies if there is a specific logic behind a measure. More information might also be found in documentation for Information Sources.
Aggregation Type: Specifies the aggregation type of a measure.
Hidden Y/N: Specifies if a measure is hidden and there by not visible to the end user when browsing the model.
Tabular Expression: The DAX expression in the measure definition.

Measure	Calculated Y/N	Contains Time Intelligence Y/N	Definition/Note (where applicable)	Aggregation Type	Hidden Y/N	Tabular Expression
Alternative Opportunity Count	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Count Alternative Opportunity] )
Annual Turnover					N	SUM ( 'BUSINESS LEAD FACT'[Annual Revenue])
Answered On Time Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Answered On Time] )
Answered On Time Count PY	N	Y			N	CALCULATE ( [Answered On Time Count], SAMEPERIODLASTYEAR ( 'DATE WANTED'[ID] ) )
Avg Ship Days Early	Y	Y		Divide	N	DIVIDE ( [Sum Ship Days Early], [Count Early Order Lines] )
Avg Ship Days Late	Y	Y		Divide	N	DIVIDE ( [Sum Ship Days Late], [Count Late Order Lines], 0 )
Avg Ship Days Off Time	Y	Y		Divide	N	DIVIDE ( [Sum Ship Days Off Time], [Count Early Order Lines] + [Count Late Order Lines] )
Base Opportunity Value Total	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Opportunity Total Value/Base] )
CO Created Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count CO Created Quote Lines] )
Cancellation Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Cancelled Quote Lines] )
Char Price Calculated	Y	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Calculated Char Price] )
Complete Order Lines %	Y	Y		Divide	N	DIVIDE ( ( [Count CO Line] - [Count Incomplete Order Line] ), [Count CO Line] )
Cost	N	N		Sum	N	SUM ( 'SALES QUOTATION LINE'[Costs] )
Cost Value Total	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Opportunity Total Cost Value] )
Count Activity	N	Y		CountRows	N	COUNTROWS ( 'BUSINESS ACTIVITY FACT' )
Count Agreement Order Lines	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_AGREEMENT_ORDER] )
Count Business Activity					N	SUM('BUSINESS ACTIVITY REFERENCE'[Count Business Activity])
Count Business Oppurntunity Conn	N	Y		Sum	N	SUM ( 'BUSINESS ACTIVITY FACT'[Count of Activity BO Connected] )
Count CO Credit	N	Y		CountRows	N	COUNTROWS ( 'CUSTOMER INVOICE' )
Count CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_ORDER_LINE] )
Count Calls					N	SUM('BUSINESS ACTIVITY FACT'[Count of Activity Calls])
Count Campaign Order Lines	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_CAMPAIGN_ORDER] )
Count Campaign Response					N	COUNTROWS ( 'MARKETING CAMPAIGN RESPONSE FACT' )
Count Chats					N	SUM('BUSINESS ACTIVITY FACT'[Count of Activity Chats])
Count Complete Order Line	N	Y			N	[Count CO Line] - [Count Incomplete Order Line]
Count Completed	N	Y		Sum	N	SUM ( 'BUSINESS ACTIVITY FACT'[Count of Activity Completed] )
Count Completed Campaign Actions					N	SUM( 'MARKETING CAMPAIGN ACTION FACT'[COUNT_COMPLETED] )
Count Completed Campaigns					N	SUM( 'MARKETING CAMPAIGN FACT'[COUNT_COMPLETED] )
Count Converted Leads					N	SUM ( 'BUSINESS LEAD FACT'[COUNT_CONVERTED] )
Count Cust Inv	N	N		CountRows	N	COUNTROWS ( 'CUSTOMER INVOICE' )
Count Delivered Not Invoiced	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_DELIVERED_NOT_INVOICED] )
Count Delivered Order Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_DELIVERED_ORDER_LINE] )
Count Delivered as Planned	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_DELIVERED_AS_PLANNED] )
Count Delivered as Promised	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_DELIVERED_AS_PROMISED] )
Count Delivered as Requested	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_DELIVERED_AS_REQUESTED] )
Count E-Mails					N	SUM('BUSINESS ACTIVITY FACT'[Count of Activity Emails])
Count Early Order Lines	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_EARLY_ORDER_LINE] )
Count In Progress	N	Y		Sum	N	SUM ( 'BUSINESS ACTIVITY FACT'[Count of Activity in Progress])
Count In Progress Campaign Actions					N	SUM ( 'MARKETING CAMPAIGN ACTION FACT'[COUNT_IN_PROGRESS] )
Count In Progress Campaigns					N	SUM( 'MARKETING CAMPAIGN FACT'[COUNT_IN_PROGRESS] )
Count In Progress Leads					N	SUM ( 'BUSINESS LEAD FACT'[COUNT_INPROGRESS] )
Count Incomplete Order Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_INCOMPLETE_ORDER_LINE] )
Count Late Order Lines	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_LATE_ORDER_LINE] )
Count Leads					N	SUM ( 'BUSINESS LEAD FACT'[LEAD_COUNT] )
Count Leads with existing Account					N	SUM ( 'BUSINESS LEAD FACT'[COUNT_ON_EXISTING_ACC] )
Count Marketing Campaign actions					N	COUNTROWS ( 'MARKETING CAMPAIGN ACTION FACT' )
Count Marketing Campaigns					N	COUNTROWS ( 'MARKETING CAMPAIGN FACT' )
Count Meetings					N	SUM('BUSINESS ACTIVITY FACT'[Count of Activity Meetings])
Count Not Started	N	Y		Sum	N	SUM ( 'BUSINESS ACTIVITY FACT'[Count of Activity Not Started])
Count Not Started Campaign Actions					N	SUM ( 'MARKETING CAMPAIGN ACTION FACT'[COUNT_NOT_STARTED] )
Count Not Started Campaigns					N	SUM( 'MARKETING CAMPAIGN FACT'[COUNT_NOT_STARTED] )
Count On Time Order Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_ON_TIME_ORDER_LINE] )
Count Parked Leads					N	SUM ( 'BUSINESS LEAD FACT'[COUNT_PARKED] )
Count Perfect Order Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_PERFECT_ORDER_LINE] )
Count PriceList Order Lines	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_PRICELIST_ORDER] )
Count RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[COUNT_ORDER_LINE] )
Count Rejected Leads					N	SUM ( 'BUSINESS LEAD FACT'[COUNT_REJECTED] )
Count Returns to Inventory RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[COUNT_RETURNS_TO_INVENTORY] )
Count Returns to Scrap RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[COUNT_RETURNS_TO_SCRAP] )
Count SalesPart Order Lines	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[COUNT_BASEPRICE_ORDER] )
Count Tasks					N	SUM('BUSINESS ACTIVITY FACT'[Count of Activity Tasks])
Count Unqualified Leads					N	SUM ( 'BUSINESS LEAD FACT'[COUNT_UNQUALIFIED] )
Current Opportunity Value Total	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Opportunity Total Value/Curr] )
Deduction Amount Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[DEDUCTION_AMOUNT] )
Disc Amount Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[DISC_AMOUNT] )
Discount Amount	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Discount] )
Discount Total	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Total Discount] )
Discount Value	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Discount Amount] )
Due By Quantity	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Quantity Due Buy] )
Due Revised Quantity	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Quantity Due Revised] )
Duration					N	SUM('BUSINESS ACTIVITY FACT'[Business Activity Duration])
Early Order Lines %	Y	Y		Divide	N	DIVIDE ( [Count Early Order Lines], [Count CO Line], BLANK () )
Estimated Opportunity Value Base	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Opportunity Estimated Value/Base] )
Gross Amount Base	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Amount Base Gross] )
Gross Amount Current	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Amount Current Gross] )
Gross Amount Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[GROSS_AMOUNT] )
Gross Amount DOM Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[GROSS_AMOUNT_DOM] )
Incomplete Order Lines %	Y	Y		Divide	N	DIVIDE ( [Count Incomplete Order Line], [Count CO Line] )
Inv Qty Received RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[INV_QTY_RECEIVED] )
Inv Qty Scrapped RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[INV_QTY_SCRAPPED] )
Inv Qty To Return RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[INV_QTY_TO_RETURN] )
Late Order Lines %	Y	Y		Divide	N	DIVIDE ( [Count Late Order Lines], [Count CO Line], BLANK () )
Lead Time Answered	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Lead Time to Answered] )
Lead Time Delivery	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Delivery Lead Time] )
Lost Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Lost Quote Lines] )
Main Opportunity Count	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Count Main Opportunity] )
Marketing Campaign Action Cost					N	SUM ( 'MARKETING CAMPAIGN ACTION FACT'[Marketing Campaign Action Cost] )
Net Amount Base	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Amount Base Net] )
Net Amount CO Credit RC	Y	N			N	SUMX ( 'CUSTOMER INVOICE', DIVIDE ( [REP_CURR_NET_AMOUNT], [Currency Rate] ) )
Net Amount CO Line RC	Y	Y			N	SUMX ( 'CUSTOMER ORDER LINE', DIVIDE ( 'CUSTOMER ORDER LINE'[REP_CURR_NET_AMOUNT], [Currency Rate] ) )
Net Amount CO Line RC 1	Y	N			N	SUMX ( 'CUSTOMER ORDER LINE', DIVIDE ( 'CUSTOMER ORDER LINE'[REP_CURR_NET_AMOUNT], [Currency Rate] ) )
Net Amount Current	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Amount Current Net] )
Net Amount Cust Inv RC	N	N			N	SUMX ( 'CUSTOMER INVOICE', DIVIDE ( [REP_CURR_NET_AMOUNT], [Currency Rate] ) )
Net Amount DOM Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[NET_AMOUNT_DOM] )
Net Amount RMA Line RC	N	N			N	SUMX ( 'RETURN MATERIAL LINE', DIVIDE ( [REP_CURR_NET_AMOUNT], [Currency Rate] ) )
Net Amount in Base Curr	N	Y		Sum	Y	[Net Amount in Base Curr CO Line] /+[Net Amount in Base Curr CO Charge]/ - [Net Amount in Base Curr RMA Line] /-[Net Amount in Base Curr RMA Charge]/ - [Net Amount in Base Curr CO Credit]
Net Amount in Base Curr CO Credit	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[NET_AMOUNT] )
Net Amount in Base Curr CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[NET_AMOUNT_BASE] )
Net Amount in Base Curr Cust Inv	N	N		Sum	N	SUM ( 'CUSTOMER INVOICE'[NET_AMOUNT] )
Net Amount in Base Curr RMA Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[NET_AMOUNT_BASE] )
Net Amount in Order Curr	N	N		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[NET_AMOUNT_CURR] )
Net Amount in Order Curr RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[NET_AMOUNT_CURR] )
Normal Opportunity Count	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Count Normal Opportunity] )
Not Invoiced Amount	Y	N			N	IF ( [Qty Sales CO Line] <> 0, ( [Qty Sales CO Line] - [Qty Invoiced CO Line] ) * ( DIVIDE ( [Net Amount in Base Curr CO Line], [Qty Sales CO Line] ) ), 0 )
Not Invoiced Base Curr CO Line	N	N		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[NET_AMOUNT_NOT_INVOICED] )
NotInvoiced Base Curr CO Line	Y	N			N	( [Qty Sales CO Line] - [Qty Invoiced CO Line] ) * DIVIDE ( [Net Amount in Base Curr CO Line], [Qty Sales CO Line] )
NotInvoiced CO Line RC	Y	N			N	( [Qty Sales CO Line] - [Qty Invoiced CO Line] ) * DIVIDE ( [Net Amount CO Line RC], [Qty Sales CO Line] )
On time Order Lines %	Y	Y		Divide	N	DIVIDE ( [Count On time Order Line], [Count CO Line] )
Open Amount Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[OPEN_AMOUNT] )
Open Amount DOM Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[OPEN_AMOUNT_DOM] )
Opportunity Base Value Not Quoted	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Not Quoted Opportunity Value/Base] )
Opportunity Base Value Quoted	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Quoted Opportunity Value/Base])
Opportunity Base Value Won	N	Y			N	SUM ( 'BUSINESS OPPORTUNITY'[Won Opportunity Value/Base] )
Opportunity Base Value Won PY	N	Y			N	CALCULATE ( [Opportunity Base Value Won], SAMEPERIODLASTYEAR ( 'DATE START'[ID] ) )
Opportunity Base Value Won R12 P	N	Y			N	CALCULATE ( [Opportunity Base Value Won R12], SAMEPERIODLASTYEAR ( 'DATE START'[ID] ) )
Opportunity Current Value Note Quoted	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Not Quoted Opportunity Value/Curr] )
Opportunity Current Value Quoted	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Quoted Opportunity Value/Curr])
Opportunity Current Value Won	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Won Opportunity Value/Curr] )
Opportunity Snapshot Count Confirmed					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_CONFIRMED_OPPS] )
Opportunity Snapshot Count In-Progress					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_INPROGRESS_OPPS] )
Opportunity Snapshot Count On Alternative					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_ON_ALTERNATE_OPP] )
Opportunity Snapshot Count On Hold					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_ONHOLD_OPPS] )
Opportunity Snapshot Count On Main					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_ON_MAIN_OPP] )
Opportunity Snapshot Count On Normal					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_ON_NORMAL_OPP] )
Opportunity Snapshot Count Unconfirmed					N	COUNT ( 'BUSINESS OPP SNAPSHOT'[COUNT_UNCONFIRMED_OPPS] )
Opportunity Snapshot Current Value					N	SUM ( 'BUSINESS OPP SNAPSHOT'[Base Current Opportunity Value] )
Opportunity Snapshot Value Estimated					N	SUM ( 'BUSINESS OPP SNAPSHOT'[Base Estimated Opportunity Value] )
Opportunity Value Estimated	N	Y		Sum	N	SUM ( 'BUSINESS OPPORTUNITY'[Opportunity Estimated Value])
Perfect Order Lines %	Y	Y		Divide	N	DIVIDE ( [Count Perfect Order Line], [Count CO Line] )
Planned Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Planned Quote Lines] )
Price Char	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Char Price] )
Price Part	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Part Price] )
Profit	Y	N			N	[Net Amount in Base Curr CO Line] - [Total Cost in Base Curr CO Line]
Profit Margin %	Y	N		Divide	N	DIVIDE ( [Profit Margin in Base Curr], [Net Amount in Base Curr], BLANK () )
Profit Margin Goal	N	N			N	0.1
Profit Margin in Base Curr	N	N			N	[Net Amount in Base Curr] - [Total Cost in Base Curr]
Qty	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Quantity] )
Qty Assigned CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_ASSIGNED] )
Qty Invoiced CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_INVOICED] )
Qty Not Invoice CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_NOT_INVOICED] )
Qty Picked CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_PICKED] )
Qty Received RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[Total Received Qty] )
Qty Returned CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_RETURNED] )
Qty Returned Inv RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[INV_QTY_RETURNED] )
Qty Sales CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[SALES_QTY] )
Qty Shipdiff CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_SHIPDIFF] )
Qty Shipped CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_SHIPPED] )
Qty Short CO Line	N	N		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[QTY_SHORT] )
Qty To Return RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[QTY_TO_RETURN] )
Rejected Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Rejected Quote Lines] )
Released Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Released Quote Lines] )
Sale Unit Price Base	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Base Sale Unit Price] )
Sale Unit Price Base Inc Tax	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Base Unit Price Inc Tax] )
Sales Quantity Customer	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Customer Sales Quantity] )
Sum Ship Days Early	N	N		Sum	Y	SUM ( 'CUSTOMER ORDER LINE'[SHIP_DAYS_EARLY] )
Sum Ship Days Late	N	N		Sum	Y	SUM ( 'CUSTOMER ORDER LINE'[SHIP_DAYS_LATE] )
Sum Ship Days Off Time	N	N		Sum	Y	SUM ( 'CUSTOMER ORDER LINE'[SHIP_DAYS_OFF_TIME] )
Total Budget Cost					N	SUM ( 'MARKETING CAMPAIGN FACT'[Marketing Campaign Total Budget Costs] )
Total Cost					N	SUM ( 'MARKETING CAMPAIGN FACT'[Marketing Campaign Total Cost] )
Total Cost CO Line RC	Y	Y			N	SUMX ( 'CUSTOMER ORDER LINE', DIVIDE ( [REP_CURR_TOTAL_COST], [Currency Rate] ) )
Total Cost RC	Y	N			N	[Total Cost CO Line RC] /+[Total Cost CO Charge RC]/ - [Total Cost RMA Line RC] /-[Total Cost RMA Charge RC]/
Total Cost RMA Line RC	Y	N			N	SUMX ( 'RETURN MATERIAL LINE', DIVIDE ( [RMA_Cost_In_Base_Curr], [Currency Rate] ) )
Total Cost in Base Curr	Y	N			Y	[Total Cost in Base Curr CO Line] /+ [Total Cost in Base Curr CO Charge]/ - [Total Cost in Base Curr RMA Line] /- [Total Cost in Base Curr RMA Charge]/
Total Cost in Base Curr CO Line	N	Y		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[TOTAL_COST] )
Total Cost in Base Curr RMA Line	N	Y		Sum	N	SUM ( 'RETURN MATERIAL LINE'[RMA_Cost_In_Base_Curr] )
Total Line Quantity	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Quantity Line Total] )
Total Opportunity Count	N	N		Count	N	COUNT ( 'BUSINESS OPPORTUNITY'[Opportunity No] )
Total Order Line Discount	N	N		Sum	N	SUM ( 'CUSTOMER ORDER LINE'[TOTAL_ORDER_LINE_DISCOUNT] )
Total Order Line Discount CO Line RC	Y	Y			N	SUMX ( 'CUSTOMER ORDER LINE', DIVIDE ( [TOTAL_ORDER_LINE_DISCOUNT], [Currency Rate] ) )
Total Sales Quotation Line Count	N	N		Count	N	COUNT ( 'SALES QUOTATION LINE'[Line Number] )
Total Value Base	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Total Base Value] )
Total Value Cost	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Total Cost Value] )
Total Value Current	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Total Current Value] )
Unit Price Base Sale	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Base Sale Unit Price] )
Unit Price Sales	N	Y		Sum	N	SUM ( 'BUSINESS OPP LINE'[Sales Unit Price] )
VAT Amount Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[VAT_AMOUNT] )
VAT Amount DOM Cust Inv	N	Y		Sum	N	SUM ( 'CUSTOMER INVOICE'[VAT_AMOUNT_DOM] )
Won Quote Lines Count	N	Y		Sum	N	SUM ( 'SALES QUOTATION LINE'[Count Won Quote Lines] )

Time Intelligence Measures

Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of the different time measures. These measures need to be used with a specific time dimension hierarchy [REPORTING_DATE].[RepDateMFHy].

Measure	Meaning
YTD	Aggregated value for current month in current year. E.g. for period 202010 Ytd represents sum of periods 202000-202010.
R12	For a given period, the sum all months from one year back up to the previous month. E.g. Rolling 12 for 202010 is the sum of months 201910 - 202009
PY	Previous Year The value of the corresponding month one year back. E.g. for month 202010, the value of month 201910.
YTD PY	Year to Date Previous Year Aggregated value for corresponding month one year back. E.g. for month 202010 YTD Previous Year represents sum of months 201901-201910.
R12 PY	Rolling 12 (completed) Months Previous Year For a given month, first going one year back, then taking the sum of all months from one (more) year back up to the previous month. E.g. for month 202010 the sum of month 201810-201909
Avg XXX Ytd	Sum XXX YTD/Count XXX YTD
Avg XXX R12	Sum XXX R12/Count XXX R12
XXX % YTD	Count XXX YTD/Count YYY YTD
XXX % R12	Count XXX R12/Count XXX R12

USED BY MODEL(S)

Model Name	Product Area
Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Additional information can be found in the online documentation of Information Sources.

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
CRM MEASURES	FACT_BUSINESS_ACTIVITY_TM, FACT BUSINESS_LEAD_CONTACT_TM, FACT_BUSINESS_OPP_TM, FACT_BUSINESS_OPP_LINE_TM, FACT_CUSTOMER_INVOICE_TM, FACT_CUSTOMER_ORDER_LINE_TM, FACT_RETURN_MATERIAL_LINE_TM, FACT_SALES_QUOTATION_LINE_TM,FACT_BUSINESS_LEAD_TM, FACT_MARKETING_CAMPAIGN_TM, FACT_MARKETING_CAMP_ACTION_TM, FACT_MKTG_ACTION_RESPONSE_TM, FACT_BUSINESS_OPP_SNAPSHOT_TM	FACT_BUSINESS_ACTIVITY_BI, FACT BUSINESS_LEAD_CONTACT_BI, FACT_BUSINESS_OPP_BI, FACT_BUSINESS_OPP_LINE_BI, FACT_CUSTOMER_INVOICE_BI, FACT_CUSTOMER_ORDER_LINE_BI, FACT_RETURN_MATERIAL_LINE_BI, FACT_SALES_QUOTATION_LINE_BI, FACT_BUSINESS_LEAD_BI, FACT_MARKETING_CAMPAIGN_BI, FACT_MARKETING_CAMP_ACTION_BI, FACT_MKTG_ACTION_RESPONSE_BI, FACT_BUSINESS_OPP_SNAPSHOT_BI	FACT_BUSINESS_ACTIVITY, FACT BUSINESS_LEAD_CONTACT, FACT_BUSINESS_OPP, FACT_BUSINESS_OPP_LINE, FACT_CUSTOMER_INVOICE, FACT_CUSTOMER_ORDER_LINE, FACT_RETURN_MATERIAL_LINE, FACT_SALES_QUOTATION_LINE, FACT_BUSINESS_LEAD, FACT_MARKETING_CAMPAIGN, FACT_MARKETING_CAMP_ACTION, FACT_MKTG_ACTION_RESPONSE, FACT_BUSINESS_OPP_SNAPSHOT	Data Mart